SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Updates a record in the Faq table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Faq_Update
(

	@Id int   ,

	@FullName nvarchar (100)  ,

	@Email nvarchar (50)  ,

	@Title nvarchar (50)  ,

	@Question nvarchar (500)  ,

	@Answer nvarchar (500)  ,

	@IsPublished bit   ,

	@ClientIp nvarchar (20)  ,

	@IsHot bit   ,

	@OrderIndex int   ,

	@AnsweredDate datetime   ,

	@AnsweredUser varchar (50)  ,

	@CreatedDate datetime   ,

	@UpdatedDate datetime   
)
AS


				
				
				-- Modify the updatable columns
				UPDATE
					[dbo].[Faq]
				SET
					[FullName] = @FullName
					,[Email] = @Email
					,[Title] = @Title
					,[Question] = @Question
					,[Answer] = @Answer
					,[IsPublished] = @IsPublished
					,[ClientIp] = @ClientIp
					,[IsHot] = @IsHot
					,[OrderIndex] = @OrderIndex
					,[AnsweredDate] = @AnsweredDate
					,[AnsweredUser] = @AnsweredUser
					,[CreatedDate] = @CreatedDate
					,[UpdatedDate] = @UpdatedDate
				WHERE
[Id] = @Id 
				
			

GO
